use Horizon
GO

INSERT INTO Sector(Sector,Description) VALUES('NY-CH','New York-Chica-New York')
INSERT INTO Sector(Sector,Description) VALUES('NY-NO','New York-New Orleans-New York')
INSERT INTO Sector(Sector,Description) VALUES('NY-MI','New York-Miami-New York')
INSERT INTO Sector(Sector,Description) VALUES('NY-PI','New York-Pittsburgh-New York')
INSERT INTO Sector(Sector,Description) VALUES('NY-ME','New York-Memphis-New York')
INSERT INTO Sector(Sector,Description) VALUES('CH-NY','Chica-New York-Chica')
INSERT INTO Sector(Sector,Description) VALUES('NO-NY','New Orleans-New York-New Orleans')
INSERT INTO Sector(Sector,Description) VALUES('Mi-NY','Miami-New York-Miami')
INSERT INTO Sector(Sector,Description) VALUES('PI-NY','Pittsburgh-New York-Pittsburgh')
INSERT INTO Sector(Sector,Description) VALUES('ME-NY','New York-Pittsburgh-New York')

INSERT INTO Aircraft VALUES ('A330','AIRBUS 330','2',18,42,280)
INSERT INTO Aircraft VALUES ('B747','BOEING 747','2',12,28,300)

INSERT INTO Fare VALUES(400,330,250)
INSERT INTO Fare VALUES(400,330,250)
INSERT INTO Fare VALUES(380,310,260)
INSERT INTO Fare VALUES(200,150,120)
INSERT INTO Fare VALUES(430,330,240)
INSERT INTO Fare VALUES(400,330,250)
INSERT INTO Fare VALUES(450,380,330)
INSERT INTO Fare VALUES(410,310,260)
INSERT INTO Fare VALUES(200,150,100)
INSERT INTO Fare VALUES(430,330,240)